/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : pet_shop

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 22/02/2023 22:04:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '地址id编号',
  `uid` int NOT NULL,
  `name` varchar(20) NOT NULL COMMENT '联系人',
  `tel` varchar(11) DEFAULT NULL COMMENT '联系方式',
  `site` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '收获地址',
  `remarks` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `address_FK` (`uid`),
  CONSTRAINT `address_FK` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of address
-- ----------------------------
BEGIN;
INSERT INTO `address` VALUES (1, 2, '小王', '110', '派出所', '学校');
INSERT INTO `address` VALUES (2, 3, '张三', '13666666666', '广东省广州市海珠区环球花园', '家');
INSERT INTO `address` VALUES (3, 4, '潇洒哥', '17888888888', '广东省广州市天河区珠江新城', '公司');
INSERT INTO `address` VALUES (7, 5, '测试人员', '13888888888', '广东省深圳市南山区测试人员中心', '系统测试');
INSERT INTO `address` VALUES (8, 6, '小昂', '63336363', '结婚的', '111');
INSERT INTO `address` VALUES (9, 7, '小金', '13888888888', '江苏海洋大学', '学校');
INSERT INTO `address` VALUES (10, 7, '八爪鱼', '18888888888', '花果山', '');
INSERT INTO `address` VALUES (11, 2, '小王', '1388888888', '江苏省连云港市海州区江苏海洋大学', '学校');
COMMIT;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `account` varchar(10) NOT NULL COMMENT '管理员名',
  `password` varchar(30) NOT NULL COMMENT '管理员密码',
  `role` tinyint NOT NULL COMMENT '管理员角色 1：超级管理员 2：普通管理员',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (101, 'superAdmin', 's123456', 1, '2022-07-11 17:13:29');
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `nid` int NOT NULL AUTO_INCREMENT COMMENT '公告编号',
  `title` varchar(50) NOT NULL COMMENT '公告标题',
  `content` text NOT NULL COMMENT '公告内容',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
INSERT INTO `notice` VALUES (1, '全场特惠!!!', '即日起至6月30日，购买店内宠物立减500元！', '2022-07-11 19:51:18');
INSERT INTO `notice` VALUES (2, '空陆宠物店即日起（6月1日）正式恢复营业，营业时间为10:00~20:00。', '我们将严格按照防疫、防控相关要求,为您营造安心、舒适、健康的购物场所。期待您的光临！', '2022-07-11 19:51:18');
INSERT INTO `notice` VALUES (3, '最新疫情防控要求', '营业时间可能会根据商场营业时间再做调整，如有您有任何疑问请联系我们。', '2022-07-11 19:51:18');
INSERT INTO `notice` VALUES (4, '连云港1号店开业了', '试业期间全场8折！！！', '2022-07-11 19:52:48');
INSERT INTO `notice` VALUES (5, '宠物咖啡！！！重磅来袭～～', '猫咖啡馆Puchi Marry主页开通。', '2022-07-17 14:33:50');
INSERT INTO `notice` VALUES (7, '测试修改公告', '测试内容～～～～', '2022-07-17 16:26:33');
INSERT INTO `notice` VALUES (8, '测试发布公告', '测试内容····', '2022-07-17 16:40:26');
INSERT INTO `notice` VALUES (9, '公布发布测试', '测试内容～～～～', '2022-07-18 11:52:57');
INSERT INTO `notice` VALUES (10, '优惠', '测试', '2022-11-29 15:41:32');
COMMIT;

-- ----------------------------
-- Table structure for pet
-- ----------------------------
DROP TABLE IF EXISTS `pet`;
CREATE TABLE `pet` (
  `No` int NOT NULL AUTO_INCREMENT COMMENT '宠物查询号码',
  `name` varchar(10) NOT NULL COMMENT '宠物名字',
  `pStatus` tinyint NOT NULL DEFAULT '1' COMMENT '宠物状态 0售出 1在售',
  `sex` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '宠物性别',
  `birthday` date NOT NULL DEFAULT '2022-04-21' COMMENT '宠物生日',
  `place` varchar(50) NOT NULL COMMENT '出生地',
  `breed` char(5) NOT NULL COMMENT '宠物毛色',
  `blood` char(10) NOT NULL COMMENT '宠物血统',
  `price` decimal(8,2) NOT NULL COMMENT '宠物价格',
  `url` varchar(200) DEFAULT NULL COMMENT '图片地址',
  `sort` tinyint(1) NOT NULL COMMENT '宠物分类：1狗 2猫 3其他',
  `features` varchar(200) DEFAULT NULL COMMENT '宠物特征',
  PRIMARY KEY (`No`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of pet
-- ----------------------------
BEGIN;
INSERT INTO `pet` VALUES (1, '杂种猫', 1, '男孩', '2022-04-21', '上海市', '灰白', '无', 8800.00, 'https://tse2-mm.cn.bing.net/th/id/OIP-C.gvD6PRKvU0TQKj5U4VPcHQHaHa?w=181&h=181&c=7&r=0&o=5&dpr=2.2&pid=1.7', 2, '体重：0.49kg( 体重测试日：2022/6/7)\n长毛小个子，像及了目前蓝白，玫红肉垫，白手套，好动');
INSERT INTO `pet` VALUES (2, '卷毛比熊犬', 1, '女孩', '2022-01-03', '上海市', '白色', '有', 9800.00, 'https://www.petking.cn/upload/dogimg/223917571.jpg', 1, '体重：0.91kg( 体重测量日：2022/02/16 )\n\n聪明开朗，感情丰富，有较强的适应能力，温和而守规矩，能给主人带来很多快乐。');
INSERT INTO `pet` VALUES (3, '杂种猫', 1, '女孩', '2022-04-29', '上海市', '黒白', '无', 8800.00, 'https://tse4-mm.cn.bing.net/th/id/OIP-C.y3AMSus4KMcbFza-uewOhgHaLH?pid=ImgDet&rs=1', 2, '体重：0.46kg( 体重测试日：2022/6/7)\n鼻尖痣，黑粉肉垫，白手套，短毛，毛色分布均匀');
INSERT INTO `pet` VALUES (4, '柴犬', 1, '男孩', '2022-01-17', '上海市', '赤色', '有', 8800.00, 'https://img.zcool.cn/community/014423586a4d1ca801219c77445446.jpg@1280w_1l_2o_100sh.jpg', 1, '体重：1.58kg( 体重测量日：2022/03/02 )\n\n头顶上的小三角耳朵微微前倾，直立着。椭圆稍小，口吻呈锥形，背部扁平而短，性格顺从。');
INSERT INTO `pet` VALUES (5, '玩具贵宾犬', 1, '男孩', '2022-04-20', '上海市', '灰色', '有', 10800.00, 'https://tse2-mm.cn.bing.net/th/id/OIP-C.D0wDLh95_OD3HtyWINoEkQAAAA?pid=ImgDet&rs=1', 1, '体重：0.66kg( 体重测量日：2022/6/7 )\n\n头颅顶部稍圆，眉头虽浅但很清晰，温顺，乖巧');
INSERT INTO `pet` VALUES (6, '威尔斯柯基犬', 1, '女孩', '2021-12-05', '上海市', '白色', '有', 9999.00, 'https://pic3.zhimg.com/v2-79bee22afd042bacaf64e8a761f9effe_r.jpg', 1, '体重：2.17kg( 体重测量日：2022/02/03 )\n\n通围脖通鼻线、黑头三色，耳根适度宽阔，立耳，体形较匀称');
INSERT INTO `pet` VALUES (7, '小猎兔犬', 1, '男孩', '2021-10-10', '上海市', '黄白', '有', 9999.00, 'https://www.petking.cn/upload/all_img/bigequanImg_H_2.jpg', 1, '体重：0.86KGkg( 体重测量日：2021/12/07 )\n\n天性活泼，四肢长，耳朵颜色均衡，好奇心重，骨骼明显');
INSERT INTO `pet` VALUES (8, '英国短毛猫', 1, '女孩', '2021-12-05', '上海市', '金色', '有', 19999.00, 'https://img.zcool.cn/community/017d275d39117da8012187f4538e0e.jpg@1280w_1l_2o_100sh.jpg', 2, '体重：1.21kg( 体重测试日：2022/2/16)\n\n性格大胆好奇，不怕生，非常温柔，不乱发脾气，不会乱吵乱叫，很喜欢亲近人，适应能力强。');
INSERT INTO `pet` VALUES (9, '缅因猫', 1, '男孩', '2022-04-21', '上海市', '黑白', '有', 29999.00, 'https://pic4.zhimg.com/v2-7815db3cad2d6594b12222dd24490657_r.jpg', 2, '体重：1.26kg( 体重测试日：2022/2/16)\n\n缅因猫头大而圆，颧骨高，耳位高，耳朵大，眼间距较宽，性情温顺，对人亲近。');
INSERT INTO `pet` VALUES (10, '英国短毛猫', 1, '男孩', '2022-04-21', '上海市', '金黄色', '有', 19999.00, 'https://img.zcool.cn/community/0164895543065d0000019ae9b098d0.jpg@1280w_1l_2o_100sh.jpg', 2, '体重：1.22kg( 体重测试日：2022/01/01)\n\n长毛11色，有着圆滚滚的脑袋和眼睛，性格大胆好奇，不怕生，非常温柔');
INSERT INTO `pet` VALUES (11, '俄罗斯蓝猫', 1, '女孩', '2022-04-21', '上海市', '灰色', '有', 19999.00, 'https://img.zcool.cn/community/0137fe5ce7876ca801209aa03e7da8.jpg@1280w_1l_2o_100sh.jpg', 2, '体重：1.3kg( 体重测量日：2021/11/18)\n\n长毛折耳，毛色均匀，脖子短，眼睛有神，活泼');
INSERT INTO `pet` VALUES (12, '西施犬', 1, '男孩', '2022-04-21', '上海市', '灰白', '无', 8999.00, 'https://www.chagougou.com/uploads/allimg/210115/1-210115163437.jpg', 1, '体重：1.52kg( 体重测试日：2021/11/18)\n\n长毛小型犬种,结构匀称，有双层被毛覆盖在整个身躯,眼睛大，圆溜溜');
INSERT INTO `pet` VALUES (13, '波斯猫', 1, '男孩', '2022-04-21', '上海市', '白色', '有', 12800.00, 'https://img.zcool.cn/community/01a44d5d3920a2a80120695cfbe450.jpg@1280w_1l_2o_100sh.jpg', 2, '体重：0.76kg( 体重测试日：2022/6/7)四肢较短，体态比波斯猫稍娇小，眼大而圆，喜欢安静，性格温顺');
INSERT INTO `pet` VALUES (14, '英国短毛猫', 1, '女孩', '2022-04-21', '上海市', '白色', '有', 8000.00, 'https://img.zcool.cn/community/01106f5ce77569a801214168a102fb.jpg@1280w_1l_2o_100sh.jpg', 2, '体重：1.22kg( 体重测试日：2022/01/18)  粉粉的鼻头，标准的蓝眼睛，毛色纯白，棕色肉垫，调皮');
INSERT INTO `pet` VALUES (17, '美国短毛猫', 1, '男孩', '2022-04-21', '上海市', '起司', '有', 10800.00, 'https://img.zcool.cn/community/016a975d392ca6a80120695ced023e.jpg@2o.jpg', 2, '体重：0.63kg( 体重测试日：2022/6/21)  背部有鱼骨纹，适应能力很强，圆头圆脑，性格温顺');
INSERT INTO `pet` VALUES (23, '法国斗牛犬', 1, '男孩', '2022-04-21', '上海市', '白色', '纯', 200000.00, 'https://www.cooriku.cn/assets/img/pet/detail/186-1.jpg', 1, '体重：0.63kg( 体重测试日：2022/6/21)  背部有鱼骨纹，适应能力很强，圆头圆脑，性格温顺');
INSERT INTO `pet` VALUES (24, '测试', 1, '男孩', '2022-04-21', '上海市', '白色', '无', 999.00, 'http://127.0.0.1:9999/1669707633588.jpeg', 1, '测试');
COMMIT;

-- ----------------------------
-- Table structure for pet_care
-- ----------------------------
DROP TABLE IF EXISTS `pet_care`;
CREATE TABLE `pet_care` (
  `cid` int NOT NULL AUTO_INCREMENT COMMENT '宠物美容订单编号',
  `cname` varchar(50) NOT NULL COMMENT '美容项目名',
  `price` decimal(10,2) NOT NULL COMMENT '普通价格',
  `member_price` decimal(10,2) NOT NULL COMMENT '会员价格',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=10019 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of pet_care
-- ----------------------------
BEGIN;
INSERT INTO `pet_care` VALUES (10010, '测试11', 111.00, 111.00);
INSERT INTO `pet_care` VALUES (10011, '马耳他犬', 300.00, 260.00);
INSERT INTO `pet_care` VALUES (10012, '西施犬', 320.00, 270.00);
INSERT INTO `pet_care` VALUES (10013, '博美犬', 320.00, 270.00);
INSERT INTO `pet_care` VALUES (10014, '金毛犬', 720.00, 610.00);
INSERT INTO `pet_care` VALUES (10016, 'ceshi', 123.00, 111.00);
INSERT INTO `pet_care` VALUES (10017, '宠物美容测试', 999.00, 888.00);
INSERT INTO `pet_care` VALUES (10018, '测试', 999.00, 999.00);
COMMIT;

-- ----------------------------
-- Table structure for pet_order
-- ----------------------------
DROP TABLE IF EXISTS `pet_order`;
CREATE TABLE `pet_order` (
  `oid` int NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `uid` int DEFAULT NULL COMMENT '用户ID',
  `No` int DEFAULT NULL COMMENT '宠物查询号码',
  `pet_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '宠物名',
  `pet_price` decimal(10,2) DEFAULT NULL COMMENT '宠物价格',
  `pet_num` int DEFAULT NULL COMMENT '宠物数量',
  `pet_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '宠物颜色',
  `pet_place` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '宠物出生地',
  `order_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '订单商品图片',
  `isSend` tinyint(1) DEFAULT '0' COMMENT '0未发货  1已发货',
  `isReturn` tinyint(1) DEFAULT '0' COMMENT '是否退货 0未退货 1已退货',
  `isCancel` tinyint(1) DEFAULT '0' COMMENT '是否取消订单 0否 1是',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '订单创建时间',
  PRIMARY KEY (`oid`),
  KEY `order_FK` (`uid`),
  KEY `order_FK_1` (`No`),
  CONSTRAINT `order_FK` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`),
  CONSTRAINT `order_FK_1` FOREIGN KEY (`No`) REFERENCES `pet` (`No`)
) ENGINE=InnoDB AUTO_INCREMENT=1022 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of pet_order
-- ----------------------------
BEGIN;
INSERT INTO `pet_order` VALUES (1001, 5, 11, '俄罗斯蓝猫', 19999.00, 1, '灰色', '上海市', 'https://img.zcool.cn/community/0137fe5ce7876ca801209aa03e7da8.jpg@1280w_1l_2o_100sh.jpg', 0, 1, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1002, 5, 11, '俄罗斯蓝猫', 19999.00, 1, '灰色', '上海市', 'https://img.zcool.cn/community/0137fe5ce7876ca801209aa03e7da8.jpg@1280w_1l_2o_100sh.jpg', 1, 0, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1003, 2, 4, '柴犬', 8800.00, 1, '赤色', '上海市', 'https://img.zcool.cn/community/014423586a4d1ca801219c77445446.jpg@1280w_1l_2o_100sh.jpg', 1, 1, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1005, 2, 8, '英国短毛猫', 19999.00, 1, '金色', '上海市', 'https://img.zcool.cn/community/017d275d39117da8012187f4538e0e.jpg@1280w_1l_2o_100sh.jpg', 1, 0, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1006, 2, 5, '玩具贵宾犬', 10800.00, 1, '灰色', '上海市', 'https://tse2-mm.cn.bing.net/th/id/OIP-C.D0wDLh95_OD3HtyWINoEkQAAAA?pid=ImgDet&rs=1', 0, 1, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1007, 2, 7, '小猎兔犬', 9999.00, 1, '黄白', '上海市', 'https://www.petking.cn/upload/all_img/bigequanImg_H_2.jpg', 0, 1, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1008, 2, 12, '西施犬', 8999.00, 1, '灰白', '上海市', 'https://www.chagougou.com/uploads/allimg/210115/1-210115163437.jpg', 0, 0, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1009, 2, 13, '波斯猫', 12800.00, 1, '白色', '上海市', 'https://img.zcool.cn/community/01a44d5d3920a2a80120695cfbe450.jpg@1280w_1l_2o_100sh.jpg', 0, 0, 1, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1010, 2, 14, '英国短毛猫', 8000.00, 1, '白色', '上海市', 'https://img.zcool.cn/community/01106f5ce77569a801214168a102fb.jpg@1280w_1l_2o_100sh.jpg', 0, 0, 1, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1011, 2, 10, '英国短毛猫', 19999.00, 1, '金黄色', '上海市', 'https://img.zcool.cn/community/0164895543065d0000019ae9b098d0.jpg@1280w_1l_2o_100sh.jpg', 0, 0, 0, '2022-07-17 15:21:16');
INSERT INTO `pet_order` VALUES (1012, 2, 11, '俄罗斯蓝猫', 19999.00, 1, '灰色', '上海市', 'https://img.zcool.cn/community/0137fe5ce7876ca801209aa03e7da8.jpg@1280w_1l_2o_100sh.jpg', 1, 0, 0, '2022-07-18 11:51:13');
INSERT INTO `pet_order` VALUES (1013, 2, 5, '玩具贵宾犬', 10800.00, 1, '灰色', '上海市', 'https://tse2-mm.cn.bing.net/th/id/OIP-C.D0wDLh95_OD3HtyWINoEkQAAAA?pid=ImgDet&rs=1', 0, 0, 0, '2022-07-21 17:46:02');
INSERT INTO `pet_order` VALUES (1014, 2, 4, '柴犬', 8800.00, 1, '赤色', '上海市', 'https://img.zcool.cn/community/014423586a4d1ca801219c77445446.jpg@1280w_1l_2o_100sh.jpg', 0, 0, 0, '2022-08-28 20:08:36');
INSERT INTO `pet_order` VALUES (1015, 2, 1, '杂种猫', 8800.00, 1, '灰白', '上海市', 'https://tse2-mm.cn.bing.net/th/id/OIP-C.gvD6PRKvU0TQKj5U4VPcHQHaHa?w=181&h=181&c=7&r=0&o=5&dpr=2.2&pid=1.7', 0, 0, 0, '2022-08-31 20:24:08');
INSERT INTO `pet_order` VALUES (1016, 6, 1, '杂种猫', 8800.00, 1, '灰白', '上海市', 'https://tse2-mm.cn.bing.net/th/id/OIP-C.gvD6PRKvU0TQKj5U4VPcHQHaHa?w=181&h=181&c=7&r=0&o=5&dpr=2.2&pid=1.7', 1, 0, 0, '2022-09-07 10:53:59');
INSERT INTO `pet_order` VALUES (1017, 6, 5, '玩具贵宾犬', 10800.00, 1, '灰色', '上海市', 'https://tse2-mm.cn.bing.net/th/id/OIP-C.D0wDLh95_OD3HtyWINoEkQAAAA?pid=ImgDet&rs=1', 0, 0, 1, '2022-09-07 10:57:57');
INSERT INTO `pet_order` VALUES (1018, 6, 4, '柴犬', 8800.00, 1, '赤色', '上海市', 'https://img.zcool.cn/community/014423586a4d1ca801219c77445446.jpg@1280w_1l_2o_100sh.jpg', 0, 1, 0, '2022-09-07 10:58:11');
INSERT INTO `pet_order` VALUES (1019, 2, 2, '卷毛比熊犬', 9800.00, 1, '白色', '上海市', 'https://www.petking.cn/upload/dogimg/223917571.jpg', 0, 0, 0, '2022-09-12 23:10:53');
INSERT INTO `pet_order` VALUES (1020, 7, 3, '杂种猫', 8800.00, 1, '黒白', '上海市', 'https://tse4-mm.cn.bing.net/th/id/OIP-C.y3AMSus4KMcbFza-uewOhgHaLH?pid=ImgDet&rs=1', 0, 0, 0, '2022-11-29 14:59:53');
INSERT INTO `pet_order` VALUES (1021, 2, 2, '卷毛比熊犬', 9800.00, 1, '白色', '上海市', 'https://www.petking.cn/upload/dogimg/223917571.jpg', 1, 0, 0, '2022-11-29 15:37:58');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` int NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `account` varchar(20) NOT NULL COMMENT '用户名',
  `password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户密码',
  `phone` varchar(11) DEFAULT NULL COMMENT '用户电话',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (2, 'wangwu', '$2a$10$mvbbxPOD.ZkDDPDJeDfzGutWASOpAIY.i5NWZtTFYqEL.YJ5x/T5u', '13666666666', '2022-07-12 10:29:56');
INSERT INTO `user` VALUES (3, 'zhangsan', '$2a$10$VhANKetCkEtAHeoVd.wnTugoywnJT5ZokPfpWz7d24zCnlprzZAmi', '13888888888', '2022-07-12 10:33:57');
INSERT INTO `user` VALUES (4, 'xiaosage', '$2a$10$tZc62hLDaAWZUCZnBdtoB.t2fFXyZA.LGFL.5r0lv4bhVD6U7WTu6', '17811112345', '2022-07-14 11:48:24');
INSERT INTO `user` VALUES (5, 'ceshi123', '$2a$10$HMOD51FfvpGjL.xF.R9rGehXdEV99bwOiwrWfjI9quEeCN0opR0Za', '13888882289', '2022-07-14 12:25:15');
INSERT INTO `user` VALUES (6, 'JinYuHao', '$2a$10$F5.03tdo/MKKEtBnGd/w0OcMidGTod3crbOOgYBkD8dOf833VIxui', '13000000000', '2022-09-07 10:50:27');
INSERT INTO `user` VALUES (7, 'jinyuhao', '$2a$10$o6wEWl2Nu.0ueqiLXbn76eyrm5uHpm9.OIDMBsQFLjwo82DGmYrni', '10086', '2022-11-29 14:50:59');
INSERT INTO `user` VALUES (8, 'lisi', '$2a$10$5CQ3WC9fDml0ACeriGgSceKuIv4Z.QA23X3g44MG3EmjMvUUik9VO', NULL, '2022-11-29 15:44:08');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
